Analyzing Olist's E-commerce Performance: Insights from a Brazilian dataset
The objective of this analysis is to enhance the performance and customer satisfaction of the e-commerce platform by leveraging data-driven insights to optimize product offerings, improve payment options and streamline order fulfillment processes.
Key Insights:
✪ The e-commerce platform has a large customer base of 99K total customers, with an average order value of $160.99.
✪ The platform experiences strong demand, with 113K total order items and 33K total products sold across 27 states.
✪ Watches, gifts, and sports/leisure products are the top-selling product categories, generating the highest total revenue.
✪ The platform has seen steady growth in total price over the years, reaching $7.4M in 2018.
✪ Credit cards are the dominant payment type, accounting for 78.54% of total payments.
Recommendations:
✪ Continue to optimize the platform's user experience and marketing strategies to attract and retain customers, leveraging insights on popular product categories and payment preferences.
✪ Invest in expanding the product catalog and inventory to meet the growing demand, particularly in the high-performing categories of watches, gifts, and sports/leisure.
✪ Explore opportunities to diversify the payment options beyond credit cards, such as integrating mobile wallets or alternative payment methods, to cater to evolving customer preferences.
✪ Leverage the insights on order status distribution to identify and address any bottlenecks in the order fulfillment process, ensuring timely deliveries.
To learn more about this project, click the view report button.